Problem Note 65194: Importing files with comma delimiters, tab delimiters, or other delimiters results in "invalid data" messages in the SAS® log
 |  |  |  |
Importing a comma-delimited file, tab-delimited file, or a file with another type of delimiter can result in the following message in the SAS log:
This message appears when the SAS program encounters a date that is missing the day portion. For example, if your date values are set to use a YYYYMMDD informat and the program encounters a YYYYMM date, the “invalid data” message appears because the day portion (DD) is missing. The variable is entered as a numeric variable with the YYMMDD10. informat and format. Prior to SAS® 9.4M6 (TS1M6), the variable was entered as a character variable with a width of 10.
There are two ways to circumvent the problem. The first workaround is to recall the generated DATA step code. Then modify the INFORMAT and FORMAT statements to use the $10. informat and the $10. format instead of the YYMMDD10. informat and format. Then resubmit the code.
The second workaround is to write a DATA step with INFILE and INPUT statements to read the external file.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | Microsoft® Windows® for x64 | 9.4 TS1M6 | 9.4 TS1M7 |
| Microsoft Windows 8 Enterprise 32-bit | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Enterprise x64 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Pro 32-bit | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8 Pro x64 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise 32-bit | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Enterprise x64 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Pro 32-bit | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 8.1 Pro x64 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows 10 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 Datacenter | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Datacenter | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 R2 Std | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2012 Std | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2016 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Microsoft Windows Server 2019 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Enterprise 32 bit | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Enterprise x64 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Home Premium 32 bit | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Home Premium x64 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Professional 32 bit | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Professional x64 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Ultimate 32 bit | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Windows 7 Ultimate x64 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| 64-bit Enabled AIX | 9.4 TS1M6 | 9.4 TS1M7 | ||
| 64-bit Enabled Solaris | 9.4 TS1M6 | 9.4 TS1M7 | ||
| HP-UX IPF | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Linux for x64 | 9.4 TS1M6 | 9.4 TS1M7 | ||
| Solaris for x64 | 9.4 TS1M6 | 9.4 TS1M7 | ||